Gets an array of SQL connections objects that satisfy the query criteria
The response body is of type SQLGetResponse.
The collection of sql connections that satify the query.
Overview
 |
SQLGetResponse
The results of the points get query
 |
SQLDefaultConnections : Array[CimSQLConnection]
An array of the CimSQLConnection objects to create/update.
 |
ODBCDataSource : string
ODBC Data connection. |
|
UserID : string
User who will connect to the selected database driver. A database user name is required if you are connecting to a SQL Server. |
|
Passsword : string
Password needed to connect to the selected database driver. A password is required if you are connecting to a SQL Server. |
|
ReconnectWaitPeriod : integer
The amount of time that the Database Logger waits between reconnect attempts when the connection to the database is lost. |
|
EnableStoreAndForward : boolean
Choose enable store and forward to enable the ALARM_LOG table perform store and forward options. |
|
MaxNumberOfStoredRecord : number
To select the number of records the Database Logger will store when its connection to the database is down. Enter a number between 1 and 4294967285. 0 indicates no limit. | |
|
SQLTableConnections : Array[CimSQLTableConnection]
An array of the CimSQLConnection objects to create/update.
|
Table_id : string
Table id on which connection is updated. |
 |
SQLConnection : CimSQLConnection
Fields that describe the connection to a SQL connection
|
ODBCDataSource : string
ODBC Data connection. |
|
UserID : string
User who will connect to the selected database driver. A database user name is required if you are connecting to a SQL Server. |
|
Passsword : string
Password needed to connect to the selected database driver. A password is required if you are connecting to a SQL Server. |
|
ReconnectWaitPeriod : integer
The amount of time that the Database Logger waits between reconnect attempts when the connection to the database is lost. |
|
EnableStoreAndForward : boolean
Choose enable store and forward to enable the ALARM_LOG table perform store and forward options. |
|
MaxNumberOfStoredRecord : number
To select the number of records the Database Logger will store when its connection to the database is down. Enter a number between 1 and 4294967285. 0 indicates no limit. | | | |